<%@ page contentType="text/html; charset=UTF-8" %>
<%@ page import="com.bstek.dorado.data.db.DBStatement" %>
<%@ page import="com.bstek.dorado.utils.variant.VariantSet" %>
<%@ page import="java.sql.Connection" %>
<%@ page import="java.sql.*" %>
<%@ page import="com.bstek.dorado.common.ds.ConnectionHelper" %>
<%@ page import="com.xr.common.CommUtil" %>
<%@ page import="oracle.sql.CLOB" %>
<html>
<head>
<title>公告板</title>
<style>
tr{
text-align:center;
font-size:10pt;
}
</style>
<SCRIPT LANGUAGE="JavaScript">
<!--


function loadForm()
{
  //editor.innerHTML=document.myform.BZXX_NR.value;
  var temp_='<head><style type=\"text/css\">body {font-size:    9pt}</style><meta http-equiv=Content-Type content=\"text/html; charset=gb2312\"></head><BODY bgcolor=\"#FFFFFF\" MONOSPACE>';
  editor.document.write(temp_+document.myform.BZXX_NR.value);
  window.opener.focus();
  return true;
}

//-->
</SCRIPT>
</head>
<body onLoad="javascipt:setTimeout('loadForm()',500);" onblur=focus();>
<form  name="myform">

<%
String ID=request.getParameter("ID");
String title="",content="",announce_type="",send_date="",employee_name="";
 Connection connection = null;
String sql="select ia.ANNOUNCE_TITLE,ia.MSG_CLASS,ia.send_date,u.employee_name,ia.ANNOUNCE_CONTENT from oa_info_announce ia,org_employee u where ia.send_man=u.employee_id and INFO_ANNOUNCE_ID="+ID;
System.out.println(sql);
try {
            connection = ConnectionHelper.getConnection(null);
            Statement st = connection.createStatement();
            ResultSet rs = st.executeQuery(sql);
            if(rs.next()){      
                title=rs.getString("ANNOUNCE_TITLE");    
                 announce_type=rs.getString("MSG_CLASS");
               // System.out.println(announce_type);
                send_date=rs.getString("send_date").substring(0,19);
                employee_name=rs.getString("employee_name");
                content=CommUtil.BlobToStr((CLOB)rs.getClob("ANNOUNCE_CONTENT"));
               
            }
            rs.close();
            st.close();
        }catch(Exception e){}finally {
                try {
                    connection.close();
                } catch (SQLException e) {
                }
        }
       
      

%>
<%!
 
%>
  <table width="100%" border="1"  cellspacing="0" >

	       <TR >
          <TD width="20%">发布人</TD>
          <TD width="80%">
   <%=employee_name%>
          </TD>
          </tr>

          <TR >
          <TD width="20%">发布时间</TD>
          <TD width="80%">
   <%=send_date%>
          </TD>
          </tr>
         <TR >
          <TD width="20%">标    题</TD>
          <TD width="80%">
   <%=title%>
          </TD>
          </tr>
        <TR>
          <TD width="20%"  valign=top>内  容</TD>
          <TD  width="80%">
         <TEXTAREA NAME="BZXX_NR" style="display:none" ROWS="0" COLS="0">
        <%=content%>
         </TEXTAREA>
       <!--   <div ID="editor" width="500" height="400"></div>-->
         

<iframe SCROLLING=yes ID="editor" src=''  width="100%" height="200"  frameborder="0" style="filter:chroma(color=#ffffff);POSITION: relative" > 
</iframe>



  <!--  <iframe ID="editor" src="../../editobject/editor.jsp" frameborder=1 scrolling=no width="500" height="400"></iframe>
  -->
          </TD>
         </TR>
<!-- 
        <TR >
          <TD width="20%">附    件</TD>
          <TD width="80%">&nbsp;



          </TD>
          </tr>
   -->
  </table>
  </form>
</body>
</html>
